[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '9' >
6 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78 | 12.45 | 1995-08-18 | Production | james0@adventure-works.com | James Kramer | 119-555-0117 | 339712426 | James | M | 2020-01-20 | Kramer | adventure-works\james0 | M | D | 9 | 1 | 119-555-0117 | 39 | 2020-01-20 | Current | Production Technician - WC60 | 39 | |
86 | 12.45 | 1999-12-13 | Production | nancy0@adventure-works.com | Nancy Anderson | 970-555-0118 | 693325305 | Nancy | F | 2020-01-26 | Anderson | adventure-works\nancy0 | M | A | 9 | 1 | 970-555-0118 | 37 | 2020-01-26 | Current | Production Technician - WC60 | 34 | |
125 | 12.45 | 1984-09-19 | Production | bryan0@adventure-works.com | Bryan Baker | 712-555-0113 | 458159238 | Bryan | M | 2020-02-14 | Baker | adventure-works\bryan0 | S | 9 | 1 | 712-555-0113 | 37 | 2020-02-14 | Current | Production Technician - WC60 | 35 | ||
39 | 12.45 | 2001-06-09 | Production | simon0@adventure-works.com | Simon Rapier | 963-555-0134 | 276751903 | Simon | M | 2020-01-01 | Rapier | adventure-works\simon0 | S | D | 9 | 1 | 963-555-0134 | 39 | 2020-01-01 | Current | Production Technician - WC60 | 38 | |
160 | 12.45 | 1987-03-05 | Production | eugene1@adventure-works.com | Eugene Kogan | 173-555-0179 | 66073987 | Eugene | M | 2020-03-03 | Kogan | adventure-works\eugene1 | S | O | 9 | 1 | 173-555-0179 | 38 | 2020-03-03 | Current | Production Technician - WC60 | 36 | |
198 | 12.45 | 1997-02-02 | Production | thomas0@adventure-works.com | Thomas Michaels | 278-555-0118 | 500412746 | Thomas | M | 2020-03-21 | Michaels | adventure-works\thomas0 | M | R | 9 | 1 | 278-555-0118 | 38 | 2020-03-21 | Current | Production Technician - WC60 | 37 |
Generated 2025-07-24 00:28:33.810 UTC